SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476610 LIMIT 1 [ RunTime:0.001364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476610 [ RunTime:0.003104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475716,21638,355236,996515,24128,950876,110487,221792,1013490,313975,305517,703895,655915,576913,812922,211106,247709,531326,932614,59517,749976,269957,618149,484849,35666,947417,729978,84069,648804,125394,587624,798865,222048,311622,861211,539834,304449,90674,770913,541223,785076,327706,171137,190502,172701,907994,473679,923795,130470,96805,240763,374368,305625,781875,196649,335391,243006,845339,549840,458629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001854s ]