SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394818 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394818 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650193,657263,364788,384549,641284,330252,785931,391774,386937,531516,819990,308851,478075,322826,400649,1773,229856,928488,1023192,563416,708126,1032437,611936,156715,160249,9386,505010,892896,946551,748539,53577,795093,67957,910068,259036,779389,583210,607667,360915,760936,993232,414850,700288,903953,225794,272295,975470,729628,365055,692190,271889,238938,27076,192309,73312,1026253,865031,294011,822760,700505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]