SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506717 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506717 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923251,633626,615322,760119,352156,936020,888912,187441,394001,417519,644895,818547,473268,363061,845055,1015282,14991,570851,518587,255071,586333,1027029,392392,1033088,103740,583366,1018605,26820,332843,168301,468015,758924,183269,138823,48956,302678,935733,124226,974225,248127,327297,954534,660724,932915,809578,548100,155274,994111,586961,358810,921747,154460,549110,377934,702174,864178,869185,701513,1000781,57081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]