SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040944 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040944 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665419,922842,1009578,794365,510607,247955,42465,868919,595041,56199,1010736,245455,565610,430430,501720,794796,893762,422091,711833,221566,58065,633917,263783,110533,761978,745798,406497,700322,826186,561249,441367,324164,498392,213558,937003,967007,995066,669661,813257,647780,850536,73530,210165,244317,580744,212133,162191,977115,993542,622349,414471,204932,289222,996391,827240,1036426,854097,19629,992547,217935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]