SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016076 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016076 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851811,983400,504427,722159,627165,903914,801290,236574,676506,976936,936150,380116,553264,958623,188826,713886,366632,143327,727395,849057,479668,615157,775478,855686,339958,825944,539996,814115,903678,81996,15722,308558,447841,415208,919916,667849,677550,638056,691000,917028,555569,246586,920887,954580,873134,998221,644402,576070,744466,114677,626863,89726,623571,664532,62674,506291,806350,600420,651841,865655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]