SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002574 LIMIT 1 [ RunTime:0.003168s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002574 [ RunTime:0.006515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249216,668561,1042772,884569,293834,688092,1015320,424917,989515,695036,489611,21378,476212,618104,819570,731038,163004,927439,127776,283152,328948,185885,996082,920076,472832,346809,331389,846539,960401,173054,167582,729807,1038959,367542,503886,793278,507911,1000606,842228,723092,117074,705538,673131,484265,570628,46733,634990,230555,505045,241790,442796,1039725,64819,437360,446447,729634,831285,873280,285412,158142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001490s ]