SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731115 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731115 [ RunTime:0.003178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604962,790801,537668,91414,434586,341657,256764,1017547,945403,717654,247433,926597,330148,573511,3524,261023,322902,111391,623512,12864,541757,883662,161685,414657,418150,285931,584221,244425,271049,287535,1020862,810001,237426,430063,634766,1000431,1044156,841052,1001217,738910,473816,619121,734151,667926,859219,926632,321764,66829,324522,75936,570184,409922,1020796,427338,82991,373546,732165,775744,490875,130096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]