SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562791 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562791 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912511,130052,960420,414215,657364,491817,792059,948531,734955,780305,43812,424014,317581,164664,83704,279748,1035089,723546,370236,231477,893569,560884,152476,191197,362915,666429,18600,195587,417093,271678,89766,411071,629391,583461,254780,971557,457010,371921,392147,19987,116596,370035,629438,1024451,33144,940756,539271,154634,62946,399597,901027,655649,772206,543997,837194,416424,109276,104331,580420,153162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]