SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426451 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426451 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731982,363465,101676,470542,478865,730487,856380,246696,93826,184606,562007,49177,519285,128949,1015888,236036,791372,675430,1024041,11979,44483,354337,628384,23264,264365,304588,227508,184430,259806,715506,626819,822051,414019,529355,75609,163740,680169,587170,579788,343217,322938,698111,297981,737292,679160,233622,226400,743172,797074,769308,717024,234302,488026,245315,921087,935003,770117,343440,908289,716364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004073s ]