SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441871 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441871 [ RunTime:0.022740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712947,911140,717627,904242,377435,499670,418866,10692,312593,178210,622982,312185,809868,845662,520782,515972,1038137,366407,951221,287234,276045,922412,1031769,22757,172078,681172,273578,946505,39606,349184,624398,817225,914511,601580,258495,447824,19274,409737,683187,165825,764919,1036242,843231,826322,716580,712024,401819,525290,797084,876748,229807,727847,964004,674907,42275,870921,137620,852438,918706,534630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]