SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506212 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506212 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516156,515336,109856,459601,753754,954216,548697,134166,980784,848664,6888,892878,482954,740038,507876,932679,447767,17406,1000829,816970,132669,470036,208685,328295,1046966,189527,607263,94229,817521,890678,571517,16745,352110,189202,576776,944769,572583,720430,833660,950503,22095,20432,518415,688908,264234,328039,618175,993760,503156,912539,78471,490465,461368,161226,83225,492231,82829,104319,357273,299607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]