SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406991 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406991 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566128,240485,457221,638158,600889,103195,526398,117409,490345,886690,440464,715852,577503,911530,338182,1036893,460457,329020,58478,867411,776709,1024939,411983,588575,942320,251018,591795,721184,793273,693501,264323,801927,708067,1018368,1001954,677055,585581,866590,822960,775627,358829,182435,103501,682261,788507,650471,476806,2764,258099,987219,148868,937515,628776,97428,378278,313060,908176,930401,925800,190277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]