SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402813 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402813 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283531,202998,1013176,575866,461647,841869,661104,686925,545601,251290,506962,855274,47310,822461,4935,397391,848075,744217,851345,907764,955631,825009,218335,629463,462352,777286,952602,173040,62699,832587,101059,11569,978391,118161,456910,712471,161937,946666,779173,800961,821196,724680,775717,790683,369561,848643,293612,779312,411075,966163,873224,865080,619736,860393,761911,354292,11670,666324,29814,964267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]