SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022865 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022865 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346412,956789,508315,784866,897081,1029178,346837,141502,930795,966018,386937,394892,291804,150679,957202,539521,467335,370282,978074,1011925,865374,508606,551285,973641,822884,655841,1039882,745307,475850,634930,79218,532297,633655,531310,79074,859586,467944,954234,980118,722124,449383,269284,819046,237460,126327,946078,30764,274797,543781,829435,753977,935188,326071,218939,910978,367192,633521,392352,590036,602134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]