SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558915 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558915 [ RunTime:0.003063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627985,926735,622370,84990,213944,504910,854641,602007,15096,892014,103377,318945,73787,410922,379563,6133,163624,124121,268665,274824,650143,688216,213505,247704,1026028,894434,944929,23370,370304,341644,138679,833385,598191,173404,318409,79009,710948,541878,334546,24285,954516,460955,965882,548721,183659,404192,261139,556939,259229,631074,11529,718320,73310,947617,638577,519851,217191,44554,390032,631129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002007s ]