SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043869 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043869 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903427,478403,791897,440530,44626,305470,561826,482931,39828,678896,248847,662840,173664,505447,273551,402866,603823,63366,885084,359046,424304,358887,877337,698671,379537,908601,309403,686087,9900,965269,86353,928089,56352,150402,945821,127914,154499,328146,1016661,421776,750843,1013672,389481,856458,704900,900835,398845,303978,1000903,1014025,955766,260212,1008571,524960,708187,516812,52065,486651,678956,1024311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043869 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043869 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]