SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047124 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047124 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505520,1035988,626934,1034547,788239,594789,78063,1026417,727683,294725,831742,120067,176131,758121,820550,521406,965941,405614,195557,806676,166319,216820,544068,250105,143688,989290,669111,140737,349258,535291,714880,858465,873501,921394,650465,848101,95518,933080,317348,994345,600043,891491,230954,708393,59009,279001,216282,902110,849109,245769,363357,497889,355727,525712,7827,416161,482808,559103,233531,327573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]