SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410314 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410314 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759718,651717,994421,542259,143127,596979,355468,531618,1013853,309245,442972,287189,918955,789018,970674,683986,1000096,638306,972289,454655,675476,172106,249144,349103,919868,319228,631239,390773,39766,7649,306798,640714,594249,908458,102041,876972,736678,104626,9183,549132,355138,1038059,246303,780406,946024,480200,83173,1014445,123290,770145,626184,29006,175691,299764,127087,354618,942818,710322,65620,463863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]