SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016850 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016850 [ RunTime:0.003655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110029,61305,293170,261679,927833,834751,913415,917694,408601,574918,103891,361037,738838,561283,709258,522629,92604,473944,985282,640985,11218,868720,259458,122974,946209,564657,878720,795373,94030,589009,464618,904716,562841,605132,977454,675464,14753,475970,1001094,447202,301083,150668,469600,296580,524944,324489,452387,1031740,56712,221619,5620,684090,101450,244773,813073,202288,600990,128019,176280,323831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]