SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331438 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331438 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415158,1021973,464363,600283,823967,114150,909413,778436,781601,378233,902707,419767,547997,34855,864921,649421,234531,269263,269606,331049,933269,603535,989099,455181,196546,875089,105501,901407,706274,807897,101877,1003639,665058,405180,552522,67676,159970,777713,556333,501256,1040233,566787,25788,691082,553991,708533,842894,168162,455732,678869,736349,471770,612502,182173,75175,898850,1042932,686531,613473,635680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]