SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003658 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003658 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476522,481694,810817,292881,835056,11431,404603,1046140,808636,525704,294359,354606,453996,751169,503738,893299,731028,189800,412400,100939,374850,550166,584861,91886,38693,66995,690601,878006,838955,580099,731690,705391,887122,947507,694328,607689,673896,799126,510451,213357,980267,140878,236874,753612,34178,372717,391650,687580,408387,73866,180368,504159,285302,689499,966585,1044330,900113,245997,730548,677674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]