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` = 1024039 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024039 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344661,791681,181020,292705,580751,41475,207533,211713,983923,139621,818540,324517,193678,143868,693865,913801,500585,328440,1034858,92257,116276,676972,434783,141990,305708,98094,228143,510094,729736,13811,8153,239947,450324,659559,1034657,315074,14734,822587,300630,532953,815217,777810,473940,653641,164354,230819,285241,1031269,561340,974362,220377,967540,666317,246674,789657,439468,231511,762448,713516,89589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]