SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668540 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668540 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413630,395283,534192,416350,8844,689913,222015,154539,805900,898823,38553,134998,1032095,719079,146799,443064,1013343,383465,136433,492553,478559,728190,437211,536223,318682,396660,449044,161355,162323,827141,471351,597531,206633,38695,4185,101784,858756,193658,543701,503600,889713,753999,357599,401787,304289,1010705,478239,1045479,89440,103518,316597,467204,396010,911031,36848,798428,289654,350675,485449,283697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]