SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587806 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587806 [ RunTime:0.006502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665132,1033363,580753,747690,33949,692216,236870,660990,1022007,95391,473936,85174,389787,545099,908627,322826,1025854,945556,476073,26980,1012366,370260,507172,268509,543699,466844,293095,256292,661306,388188,489984,709267,524549,1035966,846708,882490,236883,638055,169487,350095,323720,354255,914208,786294,945431,492082,937144,248947,220367,161542,1015393,80210,987304,799977,797351,615771,732764,507475,227998,347200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]