SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501821 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501821 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928955,752907,373431,1039399,768998,192558,842158,648722,343384,446793,332952,386355,292489,769598,652804,952970,12735,151709,479745,392458,59267,499269,133794,515189,250758,996693,404094,146668,52,973891,138758,794521,271064,245384,995173,930401,413531,720037,573516,83475,316302,715995,937056,347450,343710,493159,300302,598958,314749,763058,1000978,556236,1015056,796086,792072,359328,899849,105964,86572,1000689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]