SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041070 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041070 [ RunTime:0.002697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764853,140161,1042352,691072,331830,885384,1043209,339570,438662,407164,966960,234841,513516,240916,712714,525273,131421,364184,63154,810445,390459,530670,728603,1011138,1014243,659858,369326,284055,564314,738439,93523,193155,882043,790702,59895,787744,983766,893026,871083,550167,129259,955311,24446,1045358,112264,412389,937322,375427,421907,384192,965256,803626,524005,390449,697359,602868,190737,604114,499234,727997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001892s ]