SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463311 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463311 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799096,266733,1018714,320634,985943,676200,1033607,611279,608306,634857,427871,548089,990308,575808,473729,435091,547525,776843,18353,917907,289453,910542,631796,78666,820318,786047,494690,327143,212360,732236,201557,936793,828755,113974,124795,41700,107034,153914,164292,628495,566036,208436,453632,361763,374158,612799,211882,989010,793054,588835,1037798,935744,657421,876562,368848,620279,989223,783093,171238,356719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]