SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404219 LIMIT 1 [ RunTime:0.003857s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404219 [ RunTime:0.007576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725596,586694,877159,416925,524000,537786,938889,931509,871728,290247,339762,240815,889120,905971,739731,571377,144459,239077,878366,495197,115559,186315,368792,811162,707117,740189,380852,577112,103670,496943,712842,108941,25705,605674,620568,456681,471660,690595,748964,6861,446221,140029,45526,352705,372924,894729,1006068,899514,896627,990532,1000441,943932,453528,280142,287590,89556,346748,386409,918581,548656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]