SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 133018 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 133018 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399668,640662,335497,802022,878374,602914,213154,103621,870887,935618,303856,650575,37960,983358,449410,945207,873599,680620,1020068,764996,126346,481396,605577,955365,617845,127187,328690,43206,876357,1037247,810099,730640,180605,815901,511151,1009198,609812,56990,190377,114528,94205,60706,634757,914162,955802,744224,655321,41477,937583,75657,29151,557220,788335,834527,581103,970092,831908,562148,1019690,929057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 133018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 133018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]