SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335259 LIMIT 1 [ RunTime:0.001030s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335259 [ RunTime:0.006122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595290,571520,12150,911649,737956,204625,495430,790902,78997,764841,126306,182815,159305,163332,50538,429331,887366,106117,957653,1014879,727155,1005620,846844,252450,810261,417575,692534,184864,900513,392701,700329,436032,1007718,815487,50175,643160,489999,797739,407131,44841,835117,519666,274503,384641,763557,356153,959321,148494,551333,150329,337938,634649,352295,366893,386983,586019,742982,303927,760410,649450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]