SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531938 LIMIT 1 [ RunTime:0.008235s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531938 [ RunTime:0.003987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48072,693084,745244,1014341,135257,976619,211855,426739,991640,956825,542281,165402,1033749,663005,295165,145587,203869,86302,341291,28506,346006,757598,454807,910820,176150,282148,927381,430796,669021,207696,44671,671629,300906,20918,898128,470536,327500,513036,193887,511122,492969,910988,541817,686456,500712,776597,885583,338974,810076,977059,295611,719877,698244,821177,993383,916097,710857,1041945,706227,729439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001199s ]