SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002603s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380551 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380551 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126475,689495,132523,342381,919743,54006,466944,404646,766102,76716,845260,176924,39289,260312,36594,232915,10360,702569,187273,248635,254568,570085,612582,285647,83461,682981,524899,905485,382207,154738,800819,312847,1036198,527037,810077,682694,79225,345730,1001998,465049,898349,881764,17628,738099,111268,717145,455034,784634,741642,436976,359685,224045,689956,351914,86207,553418,868507,243048,10212,981440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]