SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501674 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501674 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026244,351371,363272,236892,173249,965826,1013825,267459,23650,642756,822781,852083,763299,33619,905388,121503,1000444,966173,265005,945914,985764,828340,972462,303973,182162,689914,940143,724449,675570,503428,220203,260488,626293,487139,259042,680938,475983,552413,169421,101663,661189,67819,342562,351638,613377,511537,617395,650961,275654,857411,727649,342863,29237,642488,692181,1030235,509002,303699,25198,1016383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]