SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555499 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555499 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863089,348873,970175,1005213,484658,433059,997357,169438,355542,572673,20887,435033,679077,606049,224073,27549,81415,715026,364552,743585,6075,800114,451581,332105,59178,76606,692728,779455,153173,906784,6557,851374,453188,622338,1017510,467376,810970,227306,963900,769275,739040,1041064,1030932,356061,267041,503946,619132,275408,51708,804594,187989,204172,872444,362052,625084,1022248,721047,764183,94816,182219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]