SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557857 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557857 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846869,410160,688859,1029913,866779,526973,337904,93407,35500,258685,1006558,443447,1033010,597614,214047,22507,906970,436307,298056,880099,871428,656324,655521,401508,868615,513745,982275,236042,739594,124494,894214,452738,679965,786222,201585,971571,411231,772039,295137,540470,821525,614192,594472,637255,116779,124160,552704,729642,321103,1015849,426158,860102,276116,275335,38786,980356,533522,689502,452262,445634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]