SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037906 LIMIT 1 [ RunTime:0.000906s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037906 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414620,129786,867252,618532,745024,1045183,796828,671667,901570,468219,731766,492436,125300,876956,233577,662065,570633,169139,993997,297543,970652,806398,220909,252478,216093,887634,434716,159867,139652,528798,398425,511936,787396,708273,832319,106688,870316,319004,335891,767027,858053,20783,1001997,760685,958314,577356,527106,621857,135683,567113,323814,683181,281249,143123,332238,111234,568854,232575,1004266,31810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]