SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522246 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522246 [ RunTime:0.004913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36728,541147,184092,217004,518311,41920,708979,355422,1010277,217174,374166,370143,561532,829667,418745,670787,122131,253248,687558,539168,1012987,280950,640623,661673,805048,392910,626586,788832,590137,78965,644562,456579,966853,820903,584022,807087,614884,179944,685883,992497,793731,760675,945355,388836,615297,516730,541225,811178,70090,6913,253404,402203,474383,767958,763082,995521,504507,232045,209902,896333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]