SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35124 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35124 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411806,689164,805380,561946,532145,554086,455549,50994,777613,218573,879161,687242,455457,913500,797115,711722,489183,902068,576171,399970,799257,310945,865203,1034664,110041,560737,814925,685478,271888,923030,149472,19320,179786,666336,442296,1012159,9340,252432,427974,330286,927313,312728,443100,98907,854550,268281,368151,742076,762025,349019,265917,568758,417861,36553,1021318,157286,417213,677174,350676,572614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]