SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035469 LIMIT 1 [ RunTime:0.001327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035469 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832363,709666,1023889,112916,611565,539249,354839,855328,1004845,146514,998897,34570,651183,750384,437001,671151,401250,482930,567480,764315,416079,567163,53943,188982,626169,286426,411603,336132,630598,7510,216382,1009063,442117,192161,104645,316361,906742,98164,442994,982556,1027919,216547,501791,464544,460813,534130,916568,103055,297879,106920,486693,210288,270962,774494,333098,232232,944441,766837,365072,179690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]