SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148251 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148251 [ RunTime:0.006440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348112,704407,511792,1824,1031143,1001440,266135,261937,670046,626544,427161,221598,696655,290682,439400,226278,762963,843220,337857,17150,275075,407907,637787,527196,567581,708837,941340,412713,92484,139325,485603,55460,67364,447194,291350,392334,142716,29919,891693,788809,415132,80720,593501,160999,355875,295522,232263,714533,463948,482716,111618,871945,277328,261715,1036808,519906,1037954,506729,1024533,434900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]