SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403291 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403291 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779443,1032406,138070,919892,255241,165551,937429,558003,780272,203020,527947,275351,859411,226992,335136,757868,182481,181201,131106,88761,1004768,497436,258653,559812,315779,29902,215428,926418,466173,236404,216764,169093,806047,1045172,612386,287662,119810,976814,415122,70880,12791,592696,379166,462690,861778,665195,837633,393021,400152,26642,605900,173255,441792,241462,59374,960975,664013,20133,709231,406667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]