SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013506 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013506 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189503,783405,379383,442489,125081,891425,353217,372382,108939,992414,243193,754188,451421,1007582,306858,748913,587303,964758,201826,123963,932537,718104,640797,21581,681800,238851,510978,177320,759049,263501,325324,531568,794028,690327,268690,869446,147996,129117,165216,336741,158636,736429,514675,747263,50461,676178,408387,898280,408685,705063,967484,524464,1046032,244016,828453,805902,988113,248854,1029767,297877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]