SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511393 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511393 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191396,1032416,217719,868835,965606,586670,287888,970030,857040,782969,730227,607752,445155,407787,358431,116839,635286,731901,514771,975828,520509,812763,571464,222912,486038,838964,529213,539538,124038,53661,784069,1039366,1012088,233619,680635,341399,825409,114115,698741,479347,966121,404036,40877,746956,386277,700082,680814,798367,473909,819520,591412,376428,506407,604074,507271,132034,537762,1025507,976873,570382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]