SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34680 LIMIT 1 [ RunTime:0.003336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34680 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784618,530372,763273,711970,679014,648998,630574,954740,2870,637105,452648,485268,754642,627904,885193,808259,77112,572203,739464,904256,669064,190239,1014370,501672,311642,456832,844111,260731,740111,1020571,478726,648342,434775,267269,743909,563684,275111,890871,636870,26980,950158,287529,573249,29228,545397,571744,1024194,105187,49593,416576,5614,826067,239899,73232,602165,615787,872443,1039786,115114,849273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]