SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36390 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36390 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245726,961222,199085,186283,597517,392775,1037258,516367,439513,287026,334518,930790,697911,161030,339971,873964,780961,133288,439959,213682,701975,365395,330705,233057,508565,550108,549184,962127,74518,903943,997589,202988,258679,903291,31704,813053,357503,997748,938314,584212,614780,895231,817845,546079,253323,457772,599130,661871,914624,344086,261125,974208,439578,662836,844985,1008076,714936,886219,541732,1030940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]