SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040649 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040649 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480687,300996,327349,184573,251919,236481,628189,36922,25005,752440,374165,93453,805935,417908,183658,770242,687321,1008878,210414,485766,554506,810103,832764,659038,622750,670225,886276,885191,644516,212999,406252,152070,359974,778724,816853,1016292,402656,100411,267160,14254,308496,78173,231461,62493,882897,517262,619925,491076,922071,498307,610564,593456,157960,802509,218002,73290,738372,806658,132240,1000309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005261s ]