SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001402 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001402 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131008,101979,470816,1020097,641735,287241,332470,662730,938270,442411,244237,1041700,229342,99843,989737,789341,874102,989275,635761,692821,1036692,52683,760065,240015,241995,462549,516142,463317,147445,549007,740981,659578,217366,1023846,728208,915505,831465,178468,430937,974653,462583,363066,27559,138420,361491,378363,659514,902970,500060,491695,424560,90446,820773,8242,458756,947362,306674,845633,681336,317677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]