SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456230 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456230 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311952,10465,1027120,1009056,187771,635289,454387,135532,744158,120291,443724,593712,728977,691852,609134,765805,699268,896689,945723,281180,257790,798072,1002810,805965,851693,334242,226462,52029,59849,197800,1015815,395431,859715,143609,5006,777663,949671,1023758,220941,397888,685875,25787,798586,555012,764266,690559,534617,991598,427367,156453,513841,457457,158138,1003988,681465,780162,420917,987291,630135,256249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]