SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422974 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422974 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955329,1029892,721296,997756,907812,809704,255044,94279,739425,69737,35024,538767,993377,80834,908601,992085,556899,890626,572291,288618,964204,837103,299965,448540,500304,610035,432968,137849,198199,734396,885381,137119,107616,636532,486585,101045,347247,39260,525856,87120,947246,17095,798492,1581,924890,359099,372380,436426,318767,925324,405766,667977,369438,300067,298071,23168,856607,1027144,111202,135834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]