SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036966 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036966 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987873,429984,774851,392378,670707,665831,774514,194174,591569,879816,880803,573051,267663,240319,73888,988034,43301,911898,489073,249356,367172,390225,733944,99083,809807,510247,76575,698816,571483,389088,994951,257665,522495,698694,383602,883237,337438,74456,893528,283007,836119,579648,124768,791333,826395,504334,227672,28647,572806,500413,496320,969767,675232,891956,996793,225289,95869,997920,892170,281645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]