SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287504 LIMIT 1 [ RunTime:0.002269s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287504 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009324,546414,861870,444552,623375,739323,464343,645620,693953,738900,939340,690731,696783,380880,1000555,107692,167067,1043980,773360,527520,258933,656735,750129,82525,426462,1038449,17037,230843,306404,919708,842173,101727,987121,851864,567111,942896,963051,1044363,553547,835683,34138,562971,376534,777102,857393,486988,519225,893763,379590,790367,383278,12089,7852,345321,192638,990977,783309,376729,474857,551299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]