SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1508 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1508 [ RunTime:0.002665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602199,312556,419886,470982,374942,1035964,808660,253311,284680,545404,166429,124301,541538,115246,128827,941478,61081,268414,43940,143627,1018733,655328,152780,988042,749007,356718,954824,746754,684500,1002121,700088,451560,711005,843122,964701,227378,531151,351896,185947,122864,94022,554290,72960,80297,221891,482383,721541,549979,685726,1047892,586462,535903,987620,336749,552454,76065,468154,259731,222988,9855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]