SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521548 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521548 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189196,710994,2043,853393,653122,84723,478043,685685,605559,1003502,478786,230316,214447,828804,180814,284548,886963,472285,574077,527769,471978,444470,1016412,200866,1012064,991972,901616,818905,178147,197070,1037630,1037614,262138,831726,513057,578368,799012,173254,448430,531150,663568,533768,945584,255020,676771,1020520,739453,627019,884759,1009553,54094,936178,350673,630999,40623,189493,89720,23708,406149,567076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]