SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006839 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006839 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464544,181188,519548,672972,277007,334601,522363,920701,303934,421692,906641,1023800,1025380,1020905,205882,364883,889205,408384,241274,776956,339048,496884,101719,435962,2482,343100,212342,261972,497165,226832,343649,310912,375687,746921,565287,601410,595707,407086,59395,722182,491071,523970,270537,389121,464656,375604,405038,844305,380556,312924,934253,76045,795919,799573,906656,645557,475547,453494,480204,552226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]