SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012389 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012389 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403857,561163,269506,760132,306382,546918,680814,125834,800505,778322,9967,960623,460846,745344,562738,544514,1018301,194950,786219,640525,368931,106355,839256,652204,631032,3739,741930,551401,327336,479067,203522,110432,914944,845589,1015744,879758,928290,882376,114286,532783,81917,490184,172120,647486,285884,759886,246542,495302,1034710,78164,299138,546683,398090,768182,456560,175718,651997,1009644,928230,22528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]