SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516584 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516584 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886447,145031,91056,606781,898780,36551,347888,245126,165846,914495,173663,262760,511418,517951,816051,467576,351348,396165,482194,788550,524631,826209,941695,272740,395797,721926,107258,134214,586495,441752,413470,869190,533195,545603,428122,733418,501267,953768,160821,961733,35580,344267,1041570,403653,48104,878522,328612,931392,41790,949096,887400,268130,648679,8081,533170,356564,61148,895022,911811,20342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]