SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103851 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103851 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24605,898779,20986,524276,922297,125424,731666,437043,410734,554922,780995,879292,709907,381078,577533,10869,1043592,408040,533793,587373,131188,665167,369478,291902,252780,277537,203406,705944,494300,967426,478019,16901,155358,655419,895179,173843,575585,581789,24969,577629,1008740,933063,389739,178711,327800,335448,799940,524188,330368,791926,764399,140853,991299,694325,254998,585797,743563,352040,76287,607990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]