SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351436 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351436 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520875,3897,800359,448889,474136,432383,491595,27928,222149,588516,532917,537198,149737,1013305,72111,765309,620080,462718,684183,35513,1032322,600440,996492,512586,832740,745409,1014733,804595,671879,836843,1046042,70299,600077,589534,756111,2678,798833,272424,830279,331073,696118,507388,232257,317615,641739,437188,648333,248536,977280,786604,853437,862912,904757,957295,166012,1026138,852394,180815,579414,375244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]