SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019087 LIMIT 1 [ RunTime:0.000595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019087 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747934,681113,487234,988613,772119,130639,190633,1032662,870737,239076,223910,106404,625858,739428,307072,712428,814840,888604,94529,196532,822720,1048476,88916,246692,83346,715944,333309,974018,288965,868914,608898,902186,11482,666263,616887,143443,1013981,956060,505676,597309,469550,96062,130512,472146,222617,932309,611373,902080,5456,336073,740367,883522,170683,175493,390255,141130,312466,713952,382815,375983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]