SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711940 LIMIT 1 [ RunTime:0.000643s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711940 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802295,89497,347938,804674,727680,555204,548570,592730,611051,542292,825464,454030,21694,24792,374369,46245,559835,841106,447066,662793,200204,367367,880019,486805,7608,9989,589373,612699,45944,671977,556535,886063,748999,845616,515660,382390,1029141,502273,735958,476020,806324,589322,454243,376271,1045153,873035,835311,954305,59915,824344,657391,683714,876687,36650,1037419,897645,48234,205923,330948,603233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]