SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502606 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502606 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356356,1013762,647158,183842,694811,56754,449591,62989,910456,361288,230392,452917,330383,5698,335628,124187,776469,375864,429376,813499,343587,213222,888260,72256,270478,80142,66089,405844,145955,379727,744733,813989,153766,639298,661028,820474,599686,532,125134,602260,238732,245520,463263,828468,144245,851890,935001,44673,354530,680333,748144,627861,1000103,221918,224299,498897,427084,736988,244040,788888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]