SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802235 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802235 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673299,342366,561996,146049,548194,91675,89844,511691,438643,632090,472056,152975,202517,727532,119270,556891,1044916,83148,534979,1042824,450713,477691,631875,690805,538541,998757,447247,967153,654931,771968,499212,212686,1039997,152085,177003,835194,756930,626070,843992,15588,235550,967660,222550,472035,398141,382436,177485,153502,194310,677799,434811,179230,720161,953028,115436,957350,687974,544834,737203,343893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]