SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501547 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501547 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697988,1030045,4639,12053,847174,403088,789518,573096,78528,71795,2647,142412,557113,312317,764000,209029,881379,193917,751570,282025,1044211,456044,432981,1019270,898281,31467,300214,503175,586709,539061,265609,415967,972010,786385,310880,377158,270271,681741,519069,683925,767503,434037,566399,955598,1017316,129013,143257,842415,440255,512992,991280,653284,28070,742786,911214,53660,816754,620431,1044041,957569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]