SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490541 LIMIT 1 [ RunTime:0.001333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490541 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356197,512493,52933,68314,910672,467145,751864,594222,683835,80412,414987,247108,542210,451194,388999,565745,400819,886591,674802,69448,164899,241235,172274,719615,781755,577233,190800,933601,1048384,596184,143328,327095,326123,93682,125797,626682,1008633,112089,924123,801730,410651,609714,568240,892751,390413,380941,896277,608661,348100,671016,421451,714222,689171,160023,259850,609611,227591,156911,9865,552359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]