SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284411 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284411 [ RunTime:0.003442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82455,256125,637547,350880,1046470,989940,890009,787261,835488,548347,763519,712213,199146,1022000,363514,879727,35530,43620,621935,960982,57519,239462,769464,539804,134015,785148,80744,507863,428264,191062,137048,237887,879894,511538,236252,531334,648781,334575,86115,71292,731400,705339,507307,3321,801876,693522,586781,696747,490280,292984,893449,351605,25438,661551,840565,728968,915452,659330,416518,742343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]