SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283118 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283118 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403264,298096,593690,74197,1041912,896496,202649,677844,546273,274196,291865,871601,244083,74988,449416,798612,133912,88433,169076,662445,293287,996112,627638,501224,881746,717490,700932,322275,698275,402287,383642,168211,12819,45784,734090,85524,162743,201633,523519,482318,811528,913883,436608,780964,417747,726407,86820,184380,16380,664703,372116,933140,610081,507912,1000821,813384,257622,95829,878795,401254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]