SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029443 LIMIT 1 [ RunTime:0.001342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029443 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371376,1035377,76016,3822,602592,490409,71455,577264,532400,226435,215250,589635,899469,983717,527326,1009010,678205,480236,542862,435494,404883,841629,519265,349302,362851,642573,644097,60397,254843,945901,493232,266843,187236,191200,510747,425840,907544,107143,344224,668811,364101,718842,760717,835375,674203,800122,24344,761832,362302,41434,918965,157780,419249,394220,68042,854908,940808,138307,571261,235921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001578s ]