SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407968 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407968 [ RunTime:0.003241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395519,869640,262082,64129,1015692,490632,337629,253903,332752,300394,758828,788981,270938,112728,498262,947517,843487,752958,247014,210904,304021,1006691,182607,450429,767941,701948,67513,526867,469728,427838,284149,623659,886482,324888,735634,335417,282601,234636,913613,469726,940540,883106,24225,820934,525927,212598,497170,387897,194779,8431,781531,385524,818297,464633,589718,863923,274088,763100,480555,334654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]