SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456891 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456891 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886594,935082,1035648,179050,281260,779527,685313,734798,503287,889511,105986,190425,914635,1034720,130168,335762,34728,1127,60470,1047934,274349,758229,418372,847945,458930,879278,725761,117607,751398,714167,538907,702114,800386,1000436,721419,791987,507732,54101,873709,443933,169890,906051,354440,529057,197619,953827,346579,898769,1003925,961428,600042,668825,620699,622662,749781,77584,531898,607342,700598,1042062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]