SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174091 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174091 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482917,644500,708912,101505,1013623,276763,242875,142741,274800,381602,944959,800345,999690,873436,1666,1018726,617441,675987,941124,412201,798621,534943,48156,570943,569525,213410,10745,997853,1024168,275019,29138,817630,655927,375680,830289,623102,43709,920161,244879,477192,431677,632262,19968,189999,51082,438583,938115,505913,853063,595479,915822,189605,48057,373564,919508,585603,501260,754280,179244,194506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]