SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516691 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516691 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020973,309822,4160,400758,1047148,728580,970235,450516,688173,53245,369707,921130,63765,990650,471201,334750,665237,614498,946234,374760,289068,150028,164863,743634,134445,196945,532886,525907,660765,549373,556606,467056,24782,332640,450493,384407,493776,652432,460317,926377,546118,8424,9190,962034,406054,204172,90484,936793,1016280,96723,415860,708115,819140,523138,734183,446533,585104,496686,704437,816798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]