SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809654 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809654 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397217,744,52495,1025005,435762,834917,209216,695428,678167,95312,440880,562347,465918,312209,92851,827201,1024035,281173,879427,12031,737752,1015452,595306,741812,308145,272703,220810,414213,869784,461806,841036,268252,4833,732449,160596,657928,422508,726099,821088,665283,848461,738081,319608,159537,894994,730510,975416,68590,495649,203619,245298,738865,44359,430549,647384,368068,9617,158386,255693,212280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]