SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541180 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541180 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110087,354160,50233,733390,354374,1037774,861912,1115,45416,571130,737241,932627,313769,1020986,90474,213028,526212,621288,45133,7427,980858,723028,801151,749690,942268,635626,437260,105968,49478,868540,966830,856923,310278,71813,740451,694614,608643,970851,823764,604643,605528,1016837,882158,725285,628634,60898,927151,743184,330168,369336,983938,720742,477597,122650,960598,691024,308518,990637,111240,202135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]