SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465074 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465074 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186419,188030,819310,238444,869214,962862,423705,861079,54375,976870,756847,1011471,315395,16209,597967,129900,392647,104854,3441,873461,85089,308908,755507,432585,569496,15762,1007891,542324,230332,998372,588211,609850,200811,983380,549055,828110,905348,334099,401897,379079,797857,979126,678703,330735,152229,828432,139707,869305,393074,205910,1003416,723487,191453,882627,232241,656319,1016392,382454,1003644,1036482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]