SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172591 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172591 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83548,182188,119257,428155,718988,483649,1020021,421079,753293,899997,24063,1005337,469686,806357,929993,210577,793264,981039,299687,613545,659007,1039824,1002691,50376,738245,1010515,595570,80016,689327,565468,135351,181861,28223,878259,900662,703345,678779,794772,438053,877973,475749,750426,521674,709835,607469,409494,1020159,304091,200997,971778,758562,285516,514705,1041436,71623,957975,998873,703774,717109,1008790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]