SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002861s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511350 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511350 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529571,263854,715341,316787,571177,587589,895832,856571,314075,253995,921182,434945,666426,1001374,430493,406619,954197,545032,893608,342540,433019,875032,309843,276545,798973,104706,915757,382867,935751,634246,470195,975657,617702,880810,1019391,435063,894867,429907,161606,10079,1013134,537629,622740,1027805,969900,448643,868228,893888,428385,379902,933284,20633,887083,734896,1041786,787585,654323,977687,373932,185041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]