SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566940 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566940 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311589,1020432,702030,297066,911088,693374,407746,68284,517407,572729,738112,233090,327946,707722,683625,238855,771002,80299,254197,936283,500732,699054,769285,786791,463464,476934,1022783,48890,861755,834120,910010,480340,293480,967740,837876,84610,558023,671258,537266,458916,486774,78718,387683,679626,207535,921594,987762,379993,290306,941416,1048187,694858,655297,187861,590313,262805,121221,823651,334774,708089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]