SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.010257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416643 LIMIT 1 [ RunTime:0.013702s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416643 [ RunTime:0.005524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262886,452451,97315,823049,386791,879273,725412,995819,467940,208788,379959,209357,897242,148667,572050,125623,826962,831488,352537,515418,419690,890517,374947,348569,368857,348013,522240,574610,509201,51958,628268,632456,493435,632983,51183,166727,819797,802969,410570,668319,317163,1002075,982174,1008072,711758,83739,50484,714058,28681,795910,583678,873725,446216,388700,532958,365416,854214,460449,714952,887445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.012218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001969s ]