SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180300 LIMIT 1 [ RunTime:0.001139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180300 [ RunTime:0.005673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901411,640596,347488,879983,290483,196018,390879,662695,495001,307202,782413,903150,773560,141217,67706,538724,310782,685129,489824,762545,980874,293897,40924,272618,211130,186616,143488,289816,560887,317070,720679,290819,796302,313416,910545,406335,388409,789724,563373,544883,934315,370946,576161,636790,377153,256471,861378,490190,597894,704108,703319,769250,895692,42180,420299,707974,949264,541682,106517,234810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]